{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Budgeter and Trend Calculator","Help"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Budgeter and Trend Calculator","index":0,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Initial Account Balance:"]
[null,4000]
[]
[null,"Monthly income:"]
[null,600]
[]
["Trends",null,null,null,null,null,"Expenses",null,null,null,"Budget"]
[null,"Income:","Expenses:","Account Balance:",null,null,"Type:","Amount:",null,null,null,"Income:","Expenses:","Account Balance:"]
["Month 1",{"$f":"B8","v":600},1080,4000,null,null,"Rent/Utilities",400,null,null,"January",{"$f":"$B$8","v":600},1240,{"$f":"$B$5","v":4000}]
["Month 2",{"$f":"$B$8","v":600},1080,{"$f":"D12+B12-C12","v":3520},null,null,"Groceries",350,null,null,"February",600,1250,{"$f":"N12+L12-M12","v":3360}]
["Month 3",{"$f":"$B$8","v":600},1080,{"$f":"D13+B13-C13","v":3040},null,null,"Phone",80,null,null,"March",600,990,{"$f":"N13+L13-M13","v":2710}]
["Month 4",600,1080,2560,null,null,"Gas",40,null,null,"April",600,990,{"$f":"N14+L14-M14","v":2320}]
["Month 5",600,1080,2080,null,null,"Medical",20,null,null,"May",600,null,1930]
["Month 6",600,1080,1600,null,null,"Car Insurance",30,null,null,"June",{"$f":"$B$8","v":600},null,2530]
["Month 7",600,1080,1120,null,null,"Date Night",20,null,null,"July",600,null,3130]
["Month 8",600,1080,640,null,null,"Miscellaneous",50,null,null,"August",600,null,3730]
["Month 9",600,1080,160,null,null,null,null,null,null,"September",600,null,4330]
["Month 10",600,null,-320,null,null,null,null,null,null,"October",600,null,4930]
["Month 11",600,null,{"$f":"D21+B21-C21","v":280},null,null,null,null,null,null,"November",600,null,5530]
["Month 12",600,null,880,null,null,null,null,null,null,"December",600,null,6130]
[]
[null,null,null,null,null,null,"Total:",{"$f":"SUM(Table2[[#All],[Column2]])","v":990},null,null,null,null,"Months Completed:",{"$f":"COUNT(Table6[[#All],[Column2]])","v":4}]

{"sheet":"Help","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["Instructions:"]
["This spreadsheet will help you with a few different things. Budgeting and tracking your spending trends."]
[null,"Set-Up:","To begin, enter your starting bank account balance in the pink box, as labled. Then enter your monthly income in the other pink box."]
[null,"Budgeter:","Enter your monthly expenses in the provided expenses table. Then simply click the 'Calculate Expenses' button. This will show you "]
[null,null,"what your account balance will be with your current income and expenses."]
[null,"Trend Calculator:","Enter your monthly expenses in the provided expenses table. Then click the 'Calculate Trend' button. The message that appears will "]
[null,null,"tell you whether or not you will still have a positive balance within a year, based on your current spending habits. "]